Troubleshoot automatic corrections

To stop automatic corrections:

1. On the Tools menu, click AutoCorrect Options.
2. To prevent all automatic corrections, on the AutoCorrect tab, clear the Replace text as you type check box.

   To prevent specific corrections, clear the corresponding check box for the option.

   Note  You can also stop AutoComplete, the feature that finishes typing a word that is used repeatedly in a column of a list after you type a few letters of the word or phrase.

   Click Options on the Tools menu, click the Edit tab, and then clear the Enable AutoComplete for cell values check box.

To exclude specified text from automatic corrections, do the following:

1. On the Tools menu, click AutoCorrect Options.
2. On the AutoCorrect tab, click Exceptions.
3. To prevent Excel from automatically capitalizing any word that is typed after an abbreviation, click the First Letter tab and type the abbreviation, including the period, in the Don't capitalize after box. The new abbreviation will appear in the list.

   To prevent Excel from automatically correcting a word that contains a mixture of uppercase and lowercase letters, click the INitial CAps tab, and then type the word in the Don't correct box.

4. Click Add, and then click OK.

To add AutoCorrect entries:

1. Click Spelling .
2. When the spell checker stops at an entry that is not in the dictionary, choose the correct spelling of the word, and then click AutoCorrect.

   Excel corrects every occurrence of the misspelling automatically.